|
|
RESULTS
// Results
$base_url = "http://www.wrestleview.com/dev/";
mysql_select_db('wrestleview_coranto'); // set the current database to the SQL Coranto DB
$sql = "select * from coranto where category = 'wwe_raw_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$raw_date = date("M j Y", $row['newstime']);
$raw_title = $row['Subject'];
$raw_link = $base_url."viewnews.php?id=".$row['newstime'];
}
$sql = "select * from coranto where category = 'wwe_smackdown_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$smackdown_date = date("M j Y", $row['newstime']);
$smackdown_title = $row['Subject'];
$smackdown_link = $base_url."viewnews.php?id=".$row['newstime'];
}
$sql = "select * from coranto where category = 'wwe_nxt_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$nxt_date = date("M j Y", $row['newstime']);
$nxt_title = $row['Subject'];
$nxt_link = $base_url."viewnews.php?id=".$row['newstime'];
}
$sql = "select * from coranto where category = 'wwe_superstars_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$superstars_date = date("M j Y", $row['newstime']);
$superstars_title = $row['Subject'];
$superstars_link = $base_url."viewnews.php?id=".$row['newstime'];
}
$sql = "select * from coranto where category = 'tna_impact_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$impact_date = date("M j Y", $row['newstime']);
$impact_title = $row['Subject'];
$impact_link = $base_url."viewnews.php?id=".$row['newstime'];
}
$sql = "select * from coranto where category = 'roh_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$roh_date = date("M j Y", $row['newstime']);
$roh_title = $row['Subject'];
$roh_link = $base_url."viewnews.php?id=".$row['newstime'];
}
$sql = "select * from coranto where category = 'wwe_ppv_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$wwe_ppv_date = date("M j Y", $row['newstime']);
$wwe_ppv_title = $row['Subject'];
$wwe_ppv_link = $base_url."viewnews.php?id=".$row['newstime'];
}
$sql = "select * from coranto where category = 'tna_ppv_results' order by newstime desc limit 1";
$rs = mysql_query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$tna_ppv_date = date("M j Y", $row['newstime']);
$tna_ppv_title = $row['Subject'];
$tna_ppv_link = $base_url."viewnews.php?id=".$row['newstime'];
}
?>
COLUMNS
|